<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html dir="ltr" xml:lang="en-gb" xmlns="http://www.w3.org/1999/xhtml"
	lang="en-gb">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
	<meta name="robots" content="index, follow">
		<meta name="keywords" content="joomla, Joomla">
			<meta name="description"
				content="Joomla! - the dynamic portal engine and content management system">
				<meta name="generator"
					content="Joomla! 1.5 - Open Source Content Management">
					<title>Welcome to the Mountain View Community Hospital</title>					
								<link rel="stylesheet" href="../image/template.css" type="text/css">
									<link rel="stylesheet" href="../image/constant.css"
										type="text/css">

										<!--equal-->
										<!--[if IE]>
   <script type="text/javascript" src="/joomla_24417/templates/theme288/scripts/ie_png.js"></script>
   <script type="text/javascript">
       ie_png.fix('.png');
	</script>
<![endif]-->
</head>
<sql:setDataSource var="datas" driver="oracle.jdbc.driver.OracleDriver"
     url="jdbc:oracle:thin:@localhost:1521:orcl"
     user="dbfp_dba"  password="dbfpdba"/>

<sql:query dataSource="${datas}" var="patient" sql="SELECT * FROM PATIENT_T NATURAL JOIN PERSON_T WHERE PERSON_ID=${personID}"/>



<body id="body">
	<!--header-->
	<div class="tail-logo">
		<div class="tail-right"></div>
		<div class="main">
			<div class="row-logo">
				<h1 style="font-size: 30px; color: white;">
					Mountain View Community Hospital
				</h1>
			</div>
		</div>
	</div>
	<div class="tail-header">
		<div class="main">
			<div class="header">
				<div class="fright">
					<div class="row-1">
						<div class="moduletable">
							<img src="../image/header_link_img_1.gif" alt="">
							<img src="../image/header_link_img_2.gif" alt="">
							<img src="../image/header_link_img_3.gif" alt="">
							<img src="../image/header_link_img_4.gif" alt="">
							<img src="../image/header_link_img_5.gif" alt="">
						</div>
					</div>
					
				</div>
				
				<div class="clear1"></div>
			</div>
		</div>
	</div>
	<div class="tail-row-top-menu clear">
		<div class="main">
			<div class="row-top-menu clear">
				<div class="fright">
					<div class="module"  style="text-align:right; margin-top: 15px;" >
					<h4>${accountID},${role},${personID}<a href="/project/resources/common/login.htm">Logout</a></h4>
					
						
					</div>

				</div>
				<div class="fleft">
					<div class="module-search">
						
					</div>
				</div>
			</div>
		</div>
	</div>
	<div class="main">
		<div class="clear wrapper-box module-login">
			<div class="box-title">
				<div class="bull-title png" style="margin-left: 400px">
					<h3>Update form</h3>
				</div>
			</div>
			<div class="box-indent">
				<div class="clear">

					<form action="/project/Register" method="post" name="update"
						class="form-login" style="margin-left: 350px">
						<c:forEach var="pupdate" items="${patient.rows}">
						<label for="mod_login_username">First Name </label> <input
							name="fname" class="inputbox" 
				            type="text" readonly value="${pupdate.person_first_name}"></input>
				             <label for="mod_login_username">Last Name </label> <input
							name="lname" class="inputbox"
				            type="text" readonly value="${pupdate.person_last_name}"></input>
				            <label
							for="mod_login_username"> Address </label> <input name="street"
							class="inputbox"
							type="text" value="${pupdate.person_street}"></input><label for="mod_login_username"> City
						</label> <input name="city" class="inputbox"
							type="text" value="${pupdate.person_city}"></input><label
							for="mod_login_username"> State </label> <input name="state"
							class="inputbox"
							type="text" value="${pupdate.person_state }"></input><label for="mod_login_username"> Zip
							</label> <input name="zip"  class="inputbox"
								 type="text" value="${pupdate.person_zip }"></input><label
									for="mod_login_username"> HomePhone </label> <input
									name="homephone"  class="inputbox"
								 type="text" value="${pupdate.person_home_phone}"></input><label
										for="mod_login_username"> WorkPhone </label> <input
										name="workphone"  class="inputbox"
										 type="text"value="${pupdate.person_work_phone}"></input><label
											for="mod_login_username"> Date Of Birth </label> <input name="birthday"
										 class="inputbox" 
											type="text" readonly value="${pupdate.person_birthdate}"></input><label for="mod_login_username">
													Email </label> <input name="email" 
												class="inputbox" type="text" value="${pupdate.person_email}"></input>
												<label for="mod_login_username">Marriage </label> <input
							                   name="marriage" class="inputbox"
				                               type="text" value="${pupdate.marriage }"></input>
				                               <label for="mod_login_username">Company </label> <input
						                    	name="company" class="inputbox"
				                                type="text" value="${pupdate.company}"></input>
				                                <label for="mod_login_username">Policy No </label> <input
							                    name="policy" class="inputbox"
				                                type="text" value="${pupdate.policy_no }"></input>
				                                <label for="mod_login_username">Group No</label> <input
						                     	name="group" class="inputbox"
				                                type="text" value="${pupdate.group_no}"></input>
				                                <label for="mod_login_username">Company Phone </label> <input
					                     		name="companyphone" class="inputbox"
				                                type="text" value="${pupdate.company_phone}"></input><label for="mod_login_username">Sub First Name </label> <input
						                     	name="sfname" class="inputbox"
				                                type="text" value="${pupdate.sub_fname}"></input>
				                                <label for="mod_login_username">Sub Last Name </label> <input
							name="slname" class="inputbox"
				            type="text" value="${pupdate.sub_lname }"></input><label for="mod_login_username">Sub Relationship</label> <input
							name="relation" class="inputbox"
				            type="text" value="${pupdate.sub_relationship }"></input><label for="mod_login_username">Sub Address </label> <input
							name="saddress" class="inputbox"
				            type="text"value="${pupdate.sub_address}"></input><label for="mod_login_username">Sub Phone </label> <input
							name="sphone" class="inputbox"
				            type="text"value="${pupdate.sub_phone }"></input>
				            </c:forEach>
						 						<br>
							<div class="clear indent-button">
								<input name="Submit" class="button png" value="Update"
									type="submit">
							</div>
							
					</form>
				</div>
			</div>
		</div>
	</div>
</body>
</html>
